package org.jeecg.modules.sistersophie.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.sistersophie.entity.CourseStudentInfo;
import org.jeecg.modules.sistersophie.entity.StudentInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.sistersophie.model.vo.CourseStudentSearchVO;

/**
 * @Description: t_student_info
 * @Author: jeecg-boot
 * @Date:   2021-05-23
 * @Version: V1.0
 */
public interface StudentInfoMapper extends BaseMapper<StudentInfo> {

      List<StudentInfo> selectByNameNotIn(@Param("firstName") String firstName,@Param("lastName") String lastName,@Param("notId") Integer notId);

      List<StudentInfo> selectByChineseNameNotIn(@Param("chineseName") String chineseName,@Param("notId") Integer notId);

      List<StudentInfo>  selectByPhoneNotIn(@Param("phone") String firstName,@Param("notId") Integer notId);

      List<StudentInfo>  selectByEmailNotIn(@Param("email") String email,@Param("notId") Integer notId);

      IPage<StudentInfo> selectStudentInfoAndNotInCourse(IPage<StudentInfo> page, @Param("searchVo") StudentInfo searchVO);
}